2013-02-13 - 4495 - Spec - Picking form for the transfer order #WMProject #APAC #picking #abapformsmm

SPECIFICATIONS

4495.1000 - Spec - Picking Form for Transfer Order

Purpose

Develop a layout for Picking of Transfer Orders as per the client requirements,Should be used for printing through LT31 and VL06O.

Admin Info

Purpose	Develop the picking form for the transfer order in LT31 and VL06O.
Requested By	Daniel Brennan
Spec Created By	Sandeep Gurram & Deepak Yasam
Spec Created Date	03/19/2013
Spec QA by	Venkat
Objects	Script : ZLVSKOMMIL1 Driver Program : RLVSDR40 Subroutine : ZWM_PICKING_SUBROUTINE
Document Status	Complete

References

Prior Tickets

None.

Documents

The below attached PDF document contains the layout of Transfer Order Picking form.

Picking Form.pdf

Functional Requirement

Use the page format 'DINA4' with orientation 'PORTRAIT'.
For the Picking form we are having a single page template, and if the data exceeds for more than one page the same page template will be called till the end of data.
In the page template we are having Header data, Item data & Footer data.

Header
Header data contains the following fields
- Transfer Order,
- Ship VIA
- Freight Terms
- Purchase Order
- Order Date
- Schedule Date
- Sales Order
- Cancel Date
- 3rd Party A/c
- Delivery No as Bar code
- Ship To Address
- Bill To Address
- Customer Specific note.

Item

Item data contains the following fields
- Transfer Order item
- Material No
- Material Description
- Size
- Batch#
- Location
- Order Qty
- Ship Qty
- UoM
- Qty(EA)

Footer

Footer part contains the following fields
- Total Qty
- Total Qty(EA)
- Page

The layout of the form is available in the below attached doc.

FSDF0011_Picking List.doc

Solution Summary

Identified the standard layout (LVSKOMMIL1) according to the requirement.
Copied the standard form to 'ZLVSKOMMIL1'.
Converted the original language to the required language.
Change the layout according the business requirement.

Printing

Picking form output can be printed by using the spool which is generated when the Transfer Order is created.

Manual Printing

To print the Picking form output manually through transaction 'LT31' ,
Input the values Transfer Order, Ware House Number & Printer details as below screen shot

Picking Form.PNG

Test Plan

Create Delivery for plants 0510 and complete TO	Print the TO using TCode LT31 manually	Test Results P/F
Create Delivery for plants 0510 and complete TO	TO should be printed automatically	Test Results P/F

Solution Details

Form Name : ZLVSKOMMIL1
Driver Program : RLVSDR40
Subroutine Pool : ZWM_PICKING_SUBROUTINE

The Driver Program 'RLVSDR40' passes the data to form for printing. In order to fetch some fields which aren't passed by the driver program, have created a Subroutine Pool.

Header fields
Hard coded the Texts of Field names used.

Form Field	Source Table	Source Field
Transfer Order	LTAK	TANUM
Ship VIA	TVV2T	BEZEI
Freight Terms	TINCT	BEZEI
Purchase Order	VBAK	BSTNK
Order Date	VBAK	AUDAT
Schedule Date	LIKP	LFDAT
Sales Order	VBAK	VBELN
Cancel Date	VBAP	J_3ACADA
Ship To Address	LIKP	KUNNR
Bill To Address	LIKP	KUNAG
Delivery Number	LTAP	VBELN
Customer Specific Note	-NA-
3rd Party Account	-NA-

Print the Delivery(VBELN) of LTAP as Barcode.
Fetching the 3rd Party A/c data from text maintained in the delivery header level whose ID is 'Z100' and OBJECT is 'VBBK'.
Fetching the Customer specific note from the text maintained in the Customer master data of the Payer(RE).
Fetching the Address Numbers of Ship To,Bill To from LIKP & ADRC tables based on the Delivery No(VBELN) of LTAK table and printing the Addresses.

Item Fields
Following are the Column names in Main Window for item details.

Line

Material

Description
Size

Batch

Location

Order Qty

Ship Qty

UoM

Qty(EA)

Form Field	Source Table	Source Field
TO Item	LTAP	TAPOS
Material	LTAP	MATNR
UPC	MEAN	EAN11
Description	LTAP	MAKTX
Size	LTAP	J_3ASIZE
Batch	LTAP	CHARG
Location	LTAP	VLPLA
Order Qty	VBAP	KWMENG
Ship Qty	LTAP	VSOLA
UoM	VBAP	MEINS
Qty(EA)	-NA-

The 'UPC No' value is based on Material Number and Size from table MEAN field 'EAN11' using sub routine pool by calling it from Script.
Fetching the Order Qty and UoM from table VBAP fields KWMENG, MEINS by obtaining the Sales order from the Delivery number of Transfer order.
Fetching the Qty(EA) value by calculating based on the UoM through Subroutine pool.

Footer Fields
In footer we are having three fields which are listed below.

Form Field	Source Table	Source Field
Total Qty	-NA-
Total Qty(EA)	-NA-
Page	-NA-	PAGE (SAP Script Variable)

Fetching the Total Qty, Total Qty(EA) by adding the quantity of Order qty and Quantity(EA) through Subroutine.

Issues

None